﻿<?xml version="1.0" encoding="utf-8" ?>
<!-- 
   Configuration options for vdbtool, dbupdate scenario, with VitaBooks MS Sql database. 
   The vdbtool generates the DDL scripts to update the database objects to match the entity model.
   The scripts can be used to manually update the database schema on production servers. 
   
   When launching vdbtool from Visual Studio, specify the following command line parameters (in project properties page):
     dbupdate /cfg:"..\..\ConfigSamples\dbupdate.mssql.books.cfg"
     
   Full command line:
    C:>vdbtool.exe dbupdate /cfg:"[path\]dbupdate.mssql.books.cfg"
   
   When playing with the tool, alter the Books database right before running the vdbtool
   - drop tables, indexes, add/remove columns. Then running vdbtool with 'dbupdate' option will generate
   the DDL SQL scripts to bring the database objects back to state matching the entity model 
   (thus undoing your modifications). 
-->
<Settings>
  <Provider>MsSql</Provider>
  <ConnectionString>Data Source=.;Initial Catalog=VitaBooks;Integrated Security=True</ConnectionString>

  <AssemblyPath>..\..\..\..\4.Samples\Vita.Samples.BooksStore\bin\debug\Vita.Samples.BookStore.dll</AssemblyPath>
  <AppClassName>Vita.Samples.BookStore.BooksEntityApp</AppClassName>
  <!-- Will go into bin folder. -->
  <OutputPath>_books.DbUpdate.sql</OutputPath>
  <!--Comma-delimited list of DbOptions enum values -->
  <DbOptions>UseRefIntegrity,UseStoredProcs,AutoIndexForeignKeys</DbOptions>
  <!--Comma-delimited list of DbModelUpdateOptions enum values -->
  <ModelUpdateOptions>UpdateTables,UpdateIndexes,UpdateStoredProcs</ModelUpdateOptions>
</Settings>